﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace SMSClient
{
	/// <summary>
	/// Interaction logic for MainWindow.xaml
	/// </summary>
	public partial class MainWindow : Window
	{
		public MainWindow()
		{
			InitializeComponent();

			/*
			 * Speaker table columns
			 * -------------------+----------------------+--------------+--------------------------
			 *  ColumnName        | DataType             |  Allow Null  |   Comment 
			 * -------------------+----------------------+--------------+--------------------------
			 *  [ID]              | [int] IDENTITY(1,1)  |  NOT NULL,   |   Auto increase number  				
             *  [SpeakerPrefixID] | [int]                |  NOT NULL,   |
				[FirstName]       | [nvarchar](100)      |  NOT NULL,   |
				[MiddleName]      | [nvarchar](100)      |  NULL,       |
				[LastName]        | [nvarchar](100)      |  NULL,       |
				[CreateDate]      | [datetime]           |  NOT NULL,   |
				[LastUpdateDate]  | [datetime]           |  NOT NULL,   |
			 * 
			 */

			/* SpeakerPrefix table columns
			 * -------------------+----------------------+--------------+------------------------
			 *  ColumnName        | DataType             |  Allow Null  |   Comment
			 * -------------------+----------------------+--------------+------------------------
			 *  [ID]              | [int] IDENTITY(1,1)  |  NOT NULL,   |   Auto increase number
				[PrefixName]      | [nchar](10)          |  NOT NULL,   |
				[Description]     | [nvarchar](100)      |  NULL,		|		
				[CreateDate]      | [datetime]           |  NOT NULL,   |
				[LastUpdateDate]  | [datetime]           |  NOT NULL,   |
			 *    
			 */
		}
	}
}
